1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="Class_DBDataSet" targetNamespace="http://tempuri.org/Class_DBDataSet.xsd" xmlns:mstns="http://tempuri.org/Class_DBDataSet.xsd" xmlns="http://tempuri.org/Class_DBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ERPS_DBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ERPS_DBConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ERP_System.My.MySettings.GlobalReference.Default.ERPS_DBConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClassTableAdapter" GeneratorDataComponentClassName="ClassTableAdapter" Name="Class" UserDataComponentName="ClassTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="ERPS_DBConnectionString (MySettings)" DbObjectName="dbo.Class" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[Class] WHERE (([ClassName] = @Original_ClassName) AND ([ClassType] = @Original_ClassType))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ClassName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Original" />
19 </Parameters>
20 </DbCommand>
21 </DeleteCommand>
22 <InsertCommand>
23 <DbCommand CommandType="Text" ModifiedByUser="false">
24 <CommandText>INSERT INTO [dbo].[Class] ([ClassName], [ClassType]) VALUES (@ClassName, @ClassType);
25 SELECT ClassName, ClassType FROM Class WHERE (ClassName = @ClassName)</CommandText>
26 <Parameters>
27 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ClassName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Current" />
28 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Current" />
29 </Parameters>
30 </DbCommand>
31 </InsertCommand>
32 <SelectCommand>
33 <DbCommand CommandType="Text" ModifiedByUser="false">
34 <CommandText>SELECT ClassName, ClassType FROM dbo.Class</CommandText>
35 <Parameters />
36 </DbCommand>
37 </SelectCommand>
38 <UpdateCommand>
39 <DbCommand CommandType="Text" ModifiedByUser="false">
40 <CommandText>UPDATE [dbo].[Class] SET [ClassName] = @ClassName, [ClassType] = @ClassType WHERE (([ClassName] = @Original_ClassName) AND ([ClassType] = @Original_ClassType));
41 SELECT ClassName, ClassType FROM Class WHERE (ClassName = @ClassName)</CommandText>
42 <Parameters>
43 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ClassName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Current" />
44 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Current" />
45 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ClassName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Original" />
46 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Original" />
47 </Parameters>
48 </DbCommand>
49 </UpdateCommand>
50 </DbSource>
51 </MainSource>
52 <Mappings>
53 <Mapping SourceColumn="ClassName" DataSetColumn="ClassName" />
54 <Mapping SourceColumn="ClassType" DataSetColumn="ClassType" />
55 </Mappings>
56 <Sources />
57 </TableAdapter>
58 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseFeeTableAdapter" GeneratorDataComponentClassName="CourseFeeTableAdapter" Name="CourseFee" UserDataComponentName="CourseFeeTableAdapter">
59 <MainSource>
60 <DbSource ConnectionRef="ERPS_DBConnectionString (MySettings)" DbObjectName="dbo.CourseFee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
61 <DeleteCommand>
62 <DbCommand CommandType="Text" ModifiedByUser="false">
63 <CommandText>DELETE FROM [dbo].[CourseFee] WHERE (([C_ID] = @Original_C_ID) AND ([SchoolID] = @Original_SchoolID) AND ([Class] = @Original_Class) AND ([FeeName] = @Original_FeeName) AND ([Semester] = @Original_Semester) AND ([Fee] = @Original_Fee))</CommandText>
64 <Parameters>
65 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_C_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
66 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Original" />
67 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
68 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FeeName" SourceColumnNullMapping="false" SourceVersion="Original" />
69 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Original" />
70 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fee" SourceColumnNullMapping="false" SourceVersion="Original" />
71 </Parameters>
72 </DbCommand>
73 </DeleteCommand>
74 <InsertCommand>
75 <DbCommand CommandType="Text" ModifiedByUser="false">
76 <CommandText>INSERT INTO [dbo].[CourseFee] ([C_ID], [SchoolID], [Class], [FeeName], [Semester], [Fee]) VALUES (@C_ID, @SchoolID, @Class, @FeeName, @Semester, @Fee);
77 SELECT C_ID, SchoolID, Class, FeeName, Semester, Fee FROM CourseFee WHERE (C_ID = @C_ID)</CommandText>
78 <Parameters>
79 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
80 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Current" />
81 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
82 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FeeName" SourceColumnNullMapping="false" SourceVersion="Current" />
83 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
84 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fee" SourceColumnNullMapping="false" SourceVersion="Current" />
85 </Parameters>
86 </DbCommand>
87 </InsertCommand>
88 <SelectCommand>
89 <DbCommand CommandType="Text" ModifiedByUser="false">
90 <CommandText>SELECT C_ID, SchoolID, Class, FeeName, Semester, Fee FROM dbo.CourseFee</CommandText>
91 <Parameters />
92 </DbCommand>
93 </SelectCommand>
94 <UpdateCommand>
95 <DbCommand CommandType="Text" ModifiedByUser="false">
96 <CommandText>UPDATE [dbo].[CourseFee] SET [C_ID] = @C_ID, [SchoolID] = @SchoolID, [Class] = @Class, [FeeName] = @FeeName, [Semester] = @Semester, [Fee] = @Fee WHERE (([C_ID] = @Original_C_ID) AND ([SchoolID] = @Original_SchoolID) AND ([Class] = @Original_Class) AND ([FeeName] = @Original_FeeName) AND ([Semester] = @Original_Semester) AND ([Fee] = @Original_Fee));
97 SELECT C_ID, SchoolID, Class, FeeName, Semester, Fee FROM CourseFee WHERE (C_ID = @C_ID)</CommandText>
98 <Parameters>
99 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
100 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Current" />
101 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
102 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FeeName" SourceColumnNullMapping="false" SourceVersion="Current" />
103 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
104 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fee" SourceColumnNullMapping="false" SourceVersion="Current" />
105 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_C_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
106 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Original" />
107 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
108 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FeeName" SourceColumnNullMapping="false" SourceVersion="Original" />
109 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Original" />
110 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fee" SourceColumnNullMapping="false" SourceVersion="Original" />
111 </Parameters>
112 </DbCommand>
113 </UpdateCommand>
114 </DbSource>
115 </MainSource>
116 <Mappings>
117 <Mapping SourceColumn="C_ID" DataSetColumn="C_ID" />
118 <Mapping SourceColumn="SchoolID" DataSetColumn="SchoolID" />
119 <Mapping SourceColumn="Class" DataSetColumn="Class" />
120 <Mapping SourceColumn="FeeName" DataSetColumn="FeeName" />
121 <Mapping SourceColumn="Semester" DataSetColumn="Semester" />
122 <Mapping SourceColumn="Fee" DataSetColumn="Fee" />
123 </Mappings>
124 <Sources />
125 </TableAdapter>
126 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseFeePaymentTableAdapter" GeneratorDataComponentClassName="CourseFeePaymentTableAdapter" Name="CourseFeePayment" UserDataComponentName="CourseFeePaymentTableAdapter">
127 <MainSource>
128 <DbSource ConnectionRef="ERPS_DBConnectionString (MySettings)" DbObjectName="dbo.CourseFeePayment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
129 <DeleteCommand>
130 <DbCommand CommandType="Text" ModifiedByUser="false">
131 <CommandText>DELETE FROM [dbo].[CourseFeePayment] WHERE (([Id] = @Original_Id) AND ([CFP_ID] = @Original_CFP_ID) AND ([PaymentID] = @Original_PaymentID) AND ([AdmissionNo] = @Original_AdmissionNo) AND ([Session] = @Original_Session) AND ([Semester] = @Original_Semester) AND ([TotalFee] = @Original_TotalFee) AND ([DiscountPer] = @Original_DiscountPer) AND ([DiscountAmt] = @Original_DiscountAmt) AND ([PreviousDue] = @Original_PreviousDue) AND ([Fine] = @Original_Fine) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPaid] = @Original_TotalPaid) AND ([ModeOfPayment] = @Original_ModeOfPayment) AND ((@IsNull_PaymentModeDetails = 1 AND [PaymentModeDetails] IS NULL) OR ([PaymentModeDetails] = @Original_PaymentModeDetails)) AND ([PaymentDate] = @Original_PaymentDate) AND ([PaymentDue] = @Original_PaymentDue) AND ([ClassType] = @Original_ClassType) AND ([SchoolType] = @Original_SchoolType) AND ([Class] = @Original_Class) AND ([Section] = @Original_Section))</CommandText>
132 <Parameters>
133 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
134 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CFP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CFP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
135 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentID" SourceColumnNullMapping="false" SourceVersion="Original" />
136 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Original" />
137 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Original" />
138 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Original" />
139 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalFee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalFee" SourceColumnNullMapping="false" SourceVersion="Original" />
140 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
141 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountAmt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountAmt" SourceColumnNullMapping="false" SourceVersion="Original" />
142 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PreviousDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PreviousDue" SourceColumnNullMapping="false" SourceVersion="Original" />
143 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fine" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Original" />
144 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
145 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
146 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
147 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaymentModeDetails" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="true" SourceVersion="Original" />
148 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Original" />
149 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
150 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Original" />
151 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Original" />
152 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Original" />
153 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
154 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Section" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Original" />
155 </Parameters>
156 </DbCommand>
157 </DeleteCommand>
158 <InsertCommand>
159 <DbCommand CommandType="Text" ModifiedByUser="false">
160 <CommandText>INSERT INTO [dbo].[CourseFeePayment] ([CFP_ID], [PaymentID], [AdmissionNo], [Session], [Semester], [TotalFee], [DiscountPer], [DiscountAmt], [PreviousDue], [Fine], [GrandTotal], [TotalPaid], [ModeOfPayment], [PaymentModeDetails], [PaymentDate], [PaymentDue], [ClassType], [SchoolType], [Class], [Section]) VALUES (@CFP_ID, @PaymentID, @AdmissionNo, @Session, @Semester, @TotalFee, @DiscountPer, @DiscountAmt, @PreviousDue, @Fine, @GrandTotal, @TotalPaid, @ModeOfPayment, @PaymentModeDetails, @PaymentDate, @PaymentDue, @ClassType, @SchoolType, @Class, @Section);
161 SELECT Id, CFP_ID, PaymentID, AdmissionNo, Session, Semester, TotalFee, DiscountPer, DiscountAmt, PreviousDue, Fine, GrandTotal, TotalPaid, ModeOfPayment, PaymentModeDetails, PaymentDate, PaymentDue, ClassType, SchoolType, Class, Section FROM CourseFeePayment WHERE (Id = SCOPE_IDENTITY())</CommandText>
162 <Parameters>
163 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CFP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CFP_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
164 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentID" SourceColumnNullMapping="false" SourceVersion="Current" />
165 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Current" />
166 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Current" />
167 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
168 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalFee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalFee" SourceColumnNullMapping="false" SourceVersion="Current" />
169 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
170 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountAmt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
171 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PreviousDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PreviousDue" SourceColumnNullMapping="false" SourceVersion="Current" />
172 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fine" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Current" />
173 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
174 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
175 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
176 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
177 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
178 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Current" />
179 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Current" />
180 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Current" />
181 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
182 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Section" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Current" />
183 </Parameters>
184 </DbCommand>
185 </InsertCommand>
186 <SelectCommand>
187 <DbCommand CommandType="Text" ModifiedByUser="false">
188 <CommandText>SELECT Id, CFP_ID, PaymentID, AdmissionNo, Session, Semester, TotalFee, DiscountPer, DiscountAmt, PreviousDue, Fine, GrandTotal, TotalPaid, ModeOfPayment, PaymentModeDetails, PaymentDate, PaymentDue, ClassType, SchoolType, Class, Section FROM dbo.CourseFeePayment</CommandText>
189 <Parameters />
190 </DbCommand>
191 </SelectCommand>
192 <UpdateCommand>
193 <DbCommand CommandType="Text" ModifiedByUser="false">
194 <CommandText>UPDATE [dbo].[CourseFeePayment] SET [CFP_ID] = @CFP_ID, [PaymentID] = @PaymentID, [AdmissionNo] = @AdmissionNo, [Session] = @Session, [Semester] = @Semester, [TotalFee] = @TotalFee, [DiscountPer] = @DiscountPer, [DiscountAmt] = @DiscountAmt, [PreviousDue] = @PreviousDue, [Fine] = @Fine, [GrandTotal] = @GrandTotal, [TotalPaid] = @TotalPaid, [ModeOfPayment] = @ModeOfPayment, [PaymentModeDetails] = @PaymentModeDetails, [PaymentDate] = @PaymentDate, [PaymentDue] = @PaymentDue, [ClassType] = @ClassType, [SchoolType] = @SchoolType, [Class] = @Class, [Section] = @Section WHERE (([Id] = @Original_Id) AND ([CFP_ID] = @Original_CFP_ID) AND ([PaymentID] = @Original_PaymentID) AND ([AdmissionNo] = @Original_AdmissionNo) AND ([Session] = @Original_Session) AND ([Semester] = @Original_Semester) AND ([TotalFee] = @Original_TotalFee) AND ([DiscountPer] = @Original_DiscountPer) AND ([DiscountAmt] = @Original_DiscountAmt) AND ([PreviousDue] = @Original_PreviousDue) AND ([Fine] = @Original_Fine) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPaid] = @Original_TotalPaid) AND ([ModeOfPayment] = @Original_ModeOfPayment) AND ((@IsNull_PaymentModeDetails = 1 AND [PaymentModeDetails] IS NULL) OR ([PaymentModeDetails] = @Original_PaymentModeDetails)) AND ([PaymentDate] = @Original_PaymentDate) AND ([PaymentDue] = @Original_PaymentDue) AND ([ClassType] = @Original_ClassType) AND ([SchoolType] = @Original_SchoolType) AND ([Class] = @Original_Class) AND ([Section] = @Original_Section));
195 SELECT Id, CFP_ID, PaymentID, AdmissionNo, Session, Semester, TotalFee, DiscountPer, DiscountAmt, PreviousDue, Fine, GrandTotal, TotalPaid, ModeOfPayment, PaymentModeDetails, PaymentDate, PaymentDue, ClassType, SchoolType, Class, Section FROM CourseFeePayment WHERE (Id = @Id)</CommandText>
196 <Parameters>
197 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CFP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CFP_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
198 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentID" SourceColumnNullMapping="false" SourceVersion="Current" />
199 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Current" />
200 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Current" />
201 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
202 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalFee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalFee" SourceColumnNullMapping="false" SourceVersion="Current" />
203 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
204 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountAmt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
205 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PreviousDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PreviousDue" SourceColumnNullMapping="false" SourceVersion="Current" />
206 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fine" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Current" />
207 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
208 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
209 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
210 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
211 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
212 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Current" />
213 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Current" />
214 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Current" />
215 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
216 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Section" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Current" />
217 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
218 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CFP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CFP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
219 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentID" SourceColumnNullMapping="false" SourceVersion="Original" />
220 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Original" />
221 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Original" />
222 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Original" />
223 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalFee" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalFee" SourceColumnNullMapping="false" SourceVersion="Original" />
224 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
225 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountAmt" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountAmt" SourceColumnNullMapping="false" SourceVersion="Original" />
226 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PreviousDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PreviousDue" SourceColumnNullMapping="false" SourceVersion="Original" />
227 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fine" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Original" />
228 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
229 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
230 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
231 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaymentModeDetails" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="true" SourceVersion="Original" />
232 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Original" />
233 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
234 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Original" />
235 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ClassType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ClassType" SourceColumnNullMapping="false" SourceVersion="Original" />
236 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Original" />
237 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
238 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Section" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Original" />
239 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[C:\USERS\RAJ SHARMA\DESKTOP\ERP SYSTEM\ERP SYSTEM\BIN\DEBUG\ERPS_DB.MDF].dbo.CourseFeePayment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
240 </Parameters>
241 </DbCommand>
242 </UpdateCommand>
243 </DbSource>
244 </MainSource>
245 <Mappings>
246 <Mapping SourceColumn="Id" DataSetColumn="Id" />
247 <Mapping SourceColumn="CFP_ID" DataSetColumn="CFP_ID" />
248 <Mapping SourceColumn="PaymentID" DataSetColumn="PaymentID" />
249 <Mapping SourceColumn="AdmissionNo" DataSetColumn="AdmissionNo" />
250 <Mapping SourceColumn="Session" DataSetColumn="Session" />
251 <Mapping SourceColumn="Semester" DataSetColumn="Semester" />
252 <Mapping SourceColumn="TotalFee" DataSetColumn="TotalFee" />
253 <Mapping SourceColumn="DiscountPer" DataSetColumn="DiscountPer" />
254 <Mapping SourceColumn="DiscountAmt" DataSetColumn="DiscountAmt" />
255 <Mapping SourceColumn="PreviousDue" DataSetColumn="PreviousDue" />
256 <Mapping SourceColumn="Fine" DataSetColumn="Fine" />
257 <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
258 <Mapping SourceColumn="TotalPaid" DataSetColumn="TotalPaid" />
259 <Mapping SourceColumn="ModeOfPayment" DataSetColumn="ModeOfPayment" />
260 <Mapping SourceColumn="PaymentModeDetails" DataSetColumn="PaymentModeDetails" />
261 <Mapping SourceColumn="PaymentDate" DataSetColumn="PaymentDate" />
262 <Mapping SourceColumn="PaymentDue" DataSetColumn="PaymentDue" />
263 <Mapping SourceColumn="ClassType" DataSetColumn="ClassType" />
264 <Mapping SourceColumn="SchoolType" DataSetColumn="SchoolType" />
265 <Mapping SourceColumn="Class" DataSetColumn="Class" />
266 <Mapping SourceColumn="Section" DataSetColumn="Section" />
267 </Mappings>
268 <Sources />
269 </TableAdapter>
270 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SchoolInfoTableAdapter" GeneratorDataComponentClassName="SchoolInfoTableAdapter" Name="SchoolInfo" UserDataComponentName="SchoolInfoTableAdapter">
271 <MainSource>
272 <DbSource ConnectionRef="ERPS_DBConnectionString (MySettings)" DbObjectName="dbo.SchoolInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
273 <DeleteCommand>
274 <DbCommand CommandType="Text" ModifiedByUser="false">
275 <CommandText>DELETE FROM [dbo].[SchoolInfo] WHERE (([S_Id] = @Original_S_Id) AND ([SchoolName] = @Original_SchoolName) AND ([Address] = @Original_Address) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_AltContactNo = 1 AND [AltContactNo] IS NULL) OR ([AltContactNo] = @Original_AltContactNo)) AND ((@IsNull_FaxNo = 1 AND [FaxNo] IS NULL) OR ([FaxNo] = @Original_FaxNo)) AND ([Email] = @Original_Email) AND ((@IsNull_Website = 1 AND [Website] IS NULL) OR ([Website] = @Original_Website)) AND ((@IsNull_RegistrationNo = 1 AND [RegistrationNo] IS NULL) OR ([RegistrationNo] = @Original_RegistrationNo)) AND ((@IsNull_DiseNo = 1 AND [DiseNo] IS NULL) OR ([DiseNo] = @Original_DiseNo)) AND ((@IsNull_IndexNo = 1 AND [IndexNo] IS NULL) OR ([IndexNo] = @Original_IndexNo)) AND ([EstablishedYear] = @Original_EstablishedYear) AND ((@IsNull_Class = 1 AND [Class] IS NULL) OR ([Class] = @Original_Class)) AND ([SchoolType] = @Original_SchoolType))</CommandText>
276 <Parameters>
277 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_S_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
278 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SchoolName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SchoolName" SourceColumnNullMapping="false" SourceVersion="Original" />
279 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
280 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
281 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AltContactNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AltContactNo" SourceColumnNullMapping="true" SourceVersion="Original" />
282 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_AltContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AltContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
283 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FaxNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="true" SourceVersion="Original" />
284 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FaxNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="false" SourceVersion="Original" />
285 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
286 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="true" SourceVersion="Original" />
287 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Original" />
288 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RegistrationNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RegistrationNo" SourceColumnNullMapping="true" SourceVersion="Original" />
289 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_RegistrationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="RegistrationNo" SourceColumnNullMapping="false" SourceVersion="Original" />
290 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiseNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiseNo" SourceColumnNullMapping="true" SourceVersion="Original" />
291 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiseNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiseNo" SourceColumnNullMapping="false" SourceVersion="Original" />
292 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IndexNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="true" SourceVersion="Original" />
293 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_IndexNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="false" SourceVersion="Original" />
294 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EstablishedYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstablishedYear" SourceColumnNullMapping="false" SourceVersion="Original" />
295 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="true" SourceVersion="Original" />
296 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
297 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Original" />
298 </Parameters>
299 </DbCommand>
300 </DeleteCommand>
301 <InsertCommand>
302 <DbCommand CommandType="Text" ModifiedByUser="false">
303 <CommandText>INSERT INTO [dbo].[SchoolInfo] ([S_Id], [SchoolName], [Address], [ContactNo], [AltContactNo], [FaxNo], [Email], [Website], [Logo], [RegistrationNo], [DiseNo], [IndexNo], [EstablishedYear], [Class], [SchoolType]) VALUES (@S_Id, @SchoolName, @Address, @ContactNo, @AltContactNo, @FaxNo, @Email, @Website, @Logo, @RegistrationNo, @DiseNo, @IndexNo, @EstablishedYear, @Class, @SchoolType);
304 SELECT S_Id, SchoolName, Address, ContactNo, AltContactNo, FaxNo, Email, Website, Logo, RegistrationNo, DiseNo, IndexNo, EstablishedYear, Class, SchoolType FROM SchoolInfo WHERE (S_Id = @S_Id)</CommandText>
305 <Parameters>
306 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@S_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
307 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SchoolName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SchoolName" SourceColumnNullMapping="false" SourceVersion="Current" />
308 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
309 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
310 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@AltContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AltContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
311 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FaxNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="false" SourceVersion="Current" />
312 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
313 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Current" />
314 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
315 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@RegistrationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="RegistrationNo" SourceColumnNullMapping="false" SourceVersion="Current" />
316 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiseNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiseNo" SourceColumnNullMapping="false" SourceVersion="Current" />
317 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@IndexNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="false" SourceVersion="Current" />
318 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EstablishedYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstablishedYear" SourceColumnNullMapping="false" SourceVersion="Current" />
319 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
320 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Current" />
321 </Parameters>
322 </DbCommand>
323 </InsertCommand>
324 <SelectCommand>
325 <DbCommand CommandType="Text" ModifiedByUser="false">
326 <CommandText>SELECT S_Id, SchoolName, Address, ContactNo, AltContactNo, FaxNo, Email, Website, Logo, RegistrationNo, DiseNo, IndexNo, EstablishedYear, Class, SchoolType FROM dbo.SchoolInfo</CommandText>
327 <Parameters />
328 </DbCommand>
329 </SelectCommand>
330 <UpdateCommand>
331 <DbCommand CommandType="Text" ModifiedByUser="false">
332 <CommandText>UPDATE [dbo].[SchoolInfo] SET [S_Id] = @S_Id, [SchoolName] = @SchoolName, [Address] = @Address, [ContactNo] = @ContactNo, [AltContactNo] = @AltContactNo, [FaxNo] = @FaxNo, [Email] = @Email, [Website] = @Website, [Logo] = @Logo, [RegistrationNo] = @RegistrationNo, [DiseNo] = @DiseNo, [IndexNo] = @IndexNo, [EstablishedYear] = @EstablishedYear, [Class] = @Class, [SchoolType] = @SchoolType WHERE (([S_Id] = @Original_S_Id) AND ([SchoolName] = @Original_SchoolName) AND ([Address] = @Original_Address) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_AltContactNo = 1 AND [AltContactNo] IS NULL) OR ([AltContactNo] = @Original_AltContactNo)) AND ((@IsNull_FaxNo = 1 AND [FaxNo] IS NULL) OR ([FaxNo] = @Original_FaxNo)) AND ([Email] = @Original_Email) AND ((@IsNull_Website = 1 AND [Website] IS NULL) OR ([Website] = @Original_Website)) AND ((@IsNull_RegistrationNo = 1 AND [RegistrationNo] IS NULL) OR ([RegistrationNo] = @Original_RegistrationNo)) AND ((@IsNull_DiseNo = 1 AND [DiseNo] IS NULL) OR ([DiseNo] = @Original_DiseNo)) AND ((@IsNull_IndexNo = 1 AND [IndexNo] IS NULL) OR ([IndexNo] = @Original_IndexNo)) AND ([EstablishedYear] = @Original_EstablishedYear) AND ((@IsNull_Class = 1 AND [Class] IS NULL) OR ([Class] = @Original_Class)) AND ([SchoolType] = @Original_SchoolType));
333 SELECT S_Id, SchoolName, Address, ContactNo, AltContactNo, FaxNo, Email, Website, Logo, RegistrationNo, DiseNo, IndexNo, EstablishedYear, Class, SchoolType FROM SchoolInfo WHERE (S_Id = @S_Id)</CommandText>
334 <Parameters>
335 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@S_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
336 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SchoolName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SchoolName" SourceColumnNullMapping="false" SourceVersion="Current" />
337 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
338 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
339 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@AltContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AltContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
340 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FaxNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="false" SourceVersion="Current" />
341 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
342 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Current" />
343 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
344 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@RegistrationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="RegistrationNo" SourceColumnNullMapping="false" SourceVersion="Current" />
345 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiseNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiseNo" SourceColumnNullMapping="false" SourceVersion="Current" />
346 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@IndexNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="false" SourceVersion="Current" />
347 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EstablishedYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstablishedYear" SourceColumnNullMapping="false" SourceVersion="Current" />
348 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
349 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Current" />
350 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_S_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
351 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SchoolName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SchoolName" SourceColumnNullMapping="false" SourceVersion="Original" />
352 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
353 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
354 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AltContactNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AltContactNo" SourceColumnNullMapping="true" SourceVersion="Original" />
355 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_AltContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AltContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
356 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FaxNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="true" SourceVersion="Original" />
357 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FaxNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="false" SourceVersion="Original" />
358 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
359 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="true" SourceVersion="Original" />
360 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Original" />
361 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RegistrationNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RegistrationNo" SourceColumnNullMapping="true" SourceVersion="Original" />
362 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_RegistrationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="RegistrationNo" SourceColumnNullMapping="false" SourceVersion="Original" />
363 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiseNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiseNo" SourceColumnNullMapping="true" SourceVersion="Original" />
364 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiseNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiseNo" SourceColumnNullMapping="false" SourceVersion="Original" />
365 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IndexNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="true" SourceVersion="Original" />
366 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_IndexNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="false" SourceVersion="Original" />
367 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EstablishedYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstablishedYear" SourceColumnNullMapping="false" SourceVersion="Original" />
368 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="true" SourceVersion="Original" />
369 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
370 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SchoolType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SchoolType" SourceColumnNullMapping="false" SourceVersion="Original" />
371 </Parameters>
372 </DbCommand>
373 </UpdateCommand>
374 </DbSource>
375 </MainSource>
376 <Mappings>
377 <Mapping SourceColumn="S_Id" DataSetColumn="S_Id" />
378 <Mapping SourceColumn="SchoolName" DataSetColumn="SchoolName" />
379 <Mapping SourceColumn="Address" DataSetColumn="Address" />
380 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
381 <Mapping SourceColumn="AltContactNo" DataSetColumn="AltContactNo" />
382 <Mapping SourceColumn="FaxNo" DataSetColumn="FaxNo" />
383 <Mapping SourceColumn="Email" DataSetColumn="Email" />
384 <Mapping SourceColumn="Website" DataSetColumn="Website" />
385 <Mapping SourceColumn="Logo" DataSetColumn="Logo" />
386 <Mapping SourceColumn="RegistrationNo" DataSetColumn="RegistrationNo" />
387 <Mapping SourceColumn="DiseNo" DataSetColumn="DiseNo" />
388 <Mapping SourceColumn="IndexNo" DataSetColumn="IndexNo" />
389 <Mapping SourceColumn="EstablishedYear" DataSetColumn="EstablishedYear" />
390 <Mapping SourceColumn="Class" DataSetColumn="Class" />
391 <Mapping SourceColumn="SchoolType" DataSetColumn="SchoolType" />
392 </Mappings>
393 <Sources />
394 </TableAdapter>
395 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentTableAdapter" GeneratorDataComponentClassName="StudentTableAdapter" Name="Student" UserDataComponentName="StudentTableAdapter">
396 <MainSource>
397 <DbSource ConnectionRef="ERPS_DBConnectionString (MySettings)" DbObjectName="dbo.Student" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
398 <DeleteCommand>
399 <DbCommand CommandType="Text" ModifiedByUser="false">
400 <CommandText>DELETE FROM [dbo].[Student] WHERE (([AdmissionNo] = @Original_AdmissionNo) AND ((@IsNull_EnrollmentNo = 1 AND [EnrollmentNo] IS NULL) OR ([EnrollmentNo] = @Original_EnrollmentNo)) AND ((@IsNull_GRNo = 1 AND [GRNo] IS NULL) OR ([GRNo] = @Original_GRNo)) AND ((@IsNull_UID = 1 AND [UID] IS NULL) OR ([UID] = @Original_UID)) AND ([StudentName] = @Original_StudentName) AND ([FatherName] = @Original_FatherName) AND ([MotherName] = @Original_MotherName) AND ((@IsNull_FatherCN = 1 AND [FatherCN] IS NULL) OR ([FatherCN] = @Original_FatherCN)) AND ([PermanentAddress] = @Original_PermanentAddress) AND ([TemporaryAddress] = @Original_TemporaryAddress) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)) AND ([DOB] = @Original_DOB) AND ([Gender] = @Original_Gender) AND ([AdmissionDate] = @Original_AdmissionDate) AND ([Session] = @Original_Session) AND ([Caste] = @Original_Caste) AND ([Religion] = @Original_Religion) AND ([SectionID] = @Original_SectionID) AND ((@IsNull_Nationality = 1 AND [Nationality] IS NULL) OR ([Nationality] = @Original_Nationality)) AND ([SchoolID] = @Original_SchoolID) AND ((@IsNull_LastSchoolAttended = 1 AND [LastSchoolAttended] IS NULL) OR ([LastSchoolAttended] = @Original_LastSchoolAttended)) AND ((@IsNull_Result = 1 AND [Result] IS NULL) OR ([Result] = @Original_Result)) AND ((@IsNull_PassPercentage = 1 AND [PassPercentage] IS NULL) OR ([PassPercentage] = @Original_PassPercentage)) AND ([Status] = @Original_Status))</CommandText>
401 <Parameters>
402 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Original" />
403 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnrollmentNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentNo" SourceColumnNullMapping="true" SourceVersion="Original" />
404 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EnrollmentNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EnrollmentNo" SourceColumnNullMapping="false" SourceVersion="Original" />
405 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GRNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRNo" SourceColumnNullMapping="true" SourceVersion="Original" />
406 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GRNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GRNo" SourceColumnNullMapping="false" SourceVersion="Original" />
407 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="true" SourceVersion="Original" />
408 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Original" />
409 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Original" />
410 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FatherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherName" SourceColumnNullMapping="false" SourceVersion="Original" />
411 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MotherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MotherName" SourceColumnNullMapping="false" SourceVersion="Original" />
412 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FatherCN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FatherCN" SourceColumnNullMapping="true" SourceVersion="Original" />
413 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FatherCN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherCN" SourceColumnNullMapping="false" SourceVersion="Original" />
414 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PermanentAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PermanentAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
415 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TemporaryAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TemporaryAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
416 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
417 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
418 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
419 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DOB" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Original" />
420 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" />
421 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_AdmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AdmissionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
422 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Original" />
423 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Caste" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Caste" SourceColumnNullMapping="false" SourceVersion="Original" />
424 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Religion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Religion" SourceColumnNullMapping="false" SourceVersion="Original" />
425 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SectionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionID" SourceColumnNullMapping="false" SourceVersion="Original" />
426 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="true" SourceVersion="Original" />
427 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nationality" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="false" SourceVersion="Original" />
428 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Original" />
429 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastSchoolAttended" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastSchoolAttended" SourceColumnNullMapping="true" SourceVersion="Original" />
430 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastSchoolAttended" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastSchoolAttended" SourceColumnNullMapping="false" SourceVersion="Original" />
431 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Result" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="true" SourceVersion="Original" />
432 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Result" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Original" />
433 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PassPercentage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PassPercentage" SourceColumnNullMapping="true" SourceVersion="Original" />
434 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PassPercentage" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PassPercentage" SourceColumnNullMapping="false" SourceVersion="Original" />
435 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
436 </Parameters>
437 </DbCommand>
438 </DeleteCommand>
439 <InsertCommand>
440 <DbCommand CommandType="Text" ModifiedByUser="false">
441 <CommandText>INSERT INTO [dbo].[Student] ([AdmissionNo], [EnrollmentNo], [GRNo], [UID], [StudentName], [FatherName], [MotherName], [FatherCN], [PermanentAddress], [TemporaryAddress], [ContactNo], [EmailID], [DOB], [Gender], [AdmissionDate], [Session], [Caste], [Religion], [SectionID], [Photo], [Nationality], [SchoolID], [LastSchoolAttended], [Result], [PassPercentage], [Status]) VALUES (@AdmissionNo, @EnrollmentNo, @GRNo, @UID, @StudentName, @FatherName, @MotherName, @FatherCN, @PermanentAddress, @TemporaryAddress, @ContactNo, @EmailID, @DOB, @Gender, @AdmissionDate, @Session, @Caste, @Religion, @SectionID, @Photo, @Nationality, @SchoolID, @LastSchoolAttended, @Result, @PassPercentage, @Status);
442 SELECT AdmissionNo, EnrollmentNo, GRNo, UID, StudentName, FatherName, MotherName, FatherCN, PermanentAddress, TemporaryAddress, ContactNo, EmailID, DOB, Gender, AdmissionDate, Session, Caste, Religion, SectionID, Photo, Nationality, SchoolID, LastSchoolAttended, Result, PassPercentage, Status FROM Student WHERE (AdmissionNo = @AdmissionNo)</CommandText>
443 <Parameters>
444 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Current" />
445 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EnrollmentNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EnrollmentNo" SourceColumnNullMapping="false" SourceVersion="Current" />
446 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GRNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GRNo" SourceColumnNullMapping="false" SourceVersion="Current" />
447 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
448 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Current" />
449 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FatherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherName" SourceColumnNullMapping="false" SourceVersion="Current" />
450 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MotherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MotherName" SourceColumnNullMapping="false" SourceVersion="Current" />
451 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FatherCN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherCN" SourceColumnNullMapping="false" SourceVersion="Current" />
452 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PermanentAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PermanentAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
453 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TemporaryAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TemporaryAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
454 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
455 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
456 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
457 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
458 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AdmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AdmissionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
459 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Current" />
460 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Caste" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Caste" SourceColumnNullMapping="false" SourceVersion="Current" />
461 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Religion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Religion" SourceColumnNullMapping="false" SourceVersion="Current" />
462 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
463 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
464 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nationality" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
465 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Current" />
466 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastSchoolAttended" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastSchoolAttended" SourceColumnNullMapping="false" SourceVersion="Current" />
467 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Result" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Current" />
468 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PassPercentage" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PassPercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
469 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
470 </Parameters>
471 </DbCommand>
472 </InsertCommand>
473 <SelectCommand>
474 <DbCommand CommandType="Text" ModifiedByUser="false">
475 <CommandText>SELECT AdmissionNo, EnrollmentNo, GRNo, UID, StudentName, FatherName, MotherName, FatherCN, PermanentAddress, TemporaryAddress, ContactNo, EmailID, DOB, Gender, AdmissionDate, Session, Caste, Religion, SectionID, Photo, Nationality, SchoolID, LastSchoolAttended, Result, PassPercentage, Status FROM dbo.Student</CommandText>
476 <Parameters />
477 </DbCommand>
478 </SelectCommand>
479 <UpdateCommand>
480 <DbCommand CommandType="Text" ModifiedByUser="false">
481 <CommandText>UPDATE [dbo].[Student] SET [AdmissionNo] = @AdmissionNo, [EnrollmentNo] = @EnrollmentNo, [GRNo] = @GRNo, [UID] = @UID, [StudentName] = @StudentName, [FatherName] = @FatherName, [MotherName] = @MotherName, [FatherCN] = @FatherCN, [PermanentAddress] = @PermanentAddress, [TemporaryAddress] = @TemporaryAddress, [ContactNo] = @ContactNo, [EmailID] = @EmailID, [DOB] = @DOB, [Gender] = @Gender, [AdmissionDate] = @AdmissionDate, [Session] = @Session, [Caste] = @Caste, [Religion] = @Religion, [SectionID] = @SectionID, [Photo] = @Photo, [Nationality] = @Nationality, [SchoolID] = @SchoolID, [LastSchoolAttended] = @LastSchoolAttended, [Result] = @Result, [PassPercentage] = @PassPercentage, [Status] = @Status WHERE (([AdmissionNo] = @Original_AdmissionNo) AND ((@IsNull_EnrollmentNo = 1 AND [EnrollmentNo] IS NULL) OR ([EnrollmentNo] = @Original_EnrollmentNo)) AND ((@IsNull_GRNo = 1 AND [GRNo] IS NULL) OR ([GRNo] = @Original_GRNo)) AND ((@IsNull_UID = 1 AND [UID] IS NULL) OR ([UID] = @Original_UID)) AND ([StudentName] = @Original_StudentName) AND ([FatherName] = @Original_FatherName) AND ([MotherName] = @Original_MotherName) AND ((@IsNull_FatherCN = 1 AND [FatherCN] IS NULL) OR ([FatherCN] = @Original_FatherCN)) AND ([PermanentAddress] = @Original_PermanentAddress) AND ([TemporaryAddress] = @Original_TemporaryAddress) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)) AND ([DOB] = @Original_DOB) AND ([Gender] = @Original_Gender) AND ([AdmissionDate] = @Original_AdmissionDate) AND ([Session] = @Original_Session) AND ([Caste] = @Original_Caste) AND ([Religion] = @Original_Religion) AND ([SectionID] = @Original_SectionID) AND ((@IsNull_Nationality = 1 AND [Nationality] IS NULL) OR ([Nationality] = @Original_Nationality)) AND ([SchoolID] = @Original_SchoolID) AND ((@IsNull_LastSchoolAttended = 1 AND [LastSchoolAttended] IS NULL) OR ([LastSchoolAttended] = @Original_LastSchoolAttended)) AND ((@IsNull_Result = 1 AND [Result] IS NULL) OR ([Result] = @Original_Result)) AND ((@IsNull_PassPercentage = 1 AND [PassPercentage] IS NULL) OR ([PassPercentage] = @Original_PassPercentage)) AND ([Status] = @Original_Status));
482 SELECT AdmissionNo, EnrollmentNo, GRNo, UID, StudentName, FatherName, MotherName, FatherCN, PermanentAddress, TemporaryAddress, ContactNo, EmailID, DOB, Gender, AdmissionDate, Session, Caste, Religion, SectionID, Photo, Nationality, SchoolID, LastSchoolAttended, Result, PassPercentage, Status FROM Student WHERE (AdmissionNo = @AdmissionNo)</CommandText>
483 <Parameters>
484 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Current" />
485 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EnrollmentNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EnrollmentNo" SourceColumnNullMapping="false" SourceVersion="Current" />
486 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GRNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GRNo" SourceColumnNullMapping="false" SourceVersion="Current" />
487 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
488 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Current" />
489 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FatherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherName" SourceColumnNullMapping="false" SourceVersion="Current" />
490 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MotherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MotherName" SourceColumnNullMapping="false" SourceVersion="Current" />
491 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FatherCN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherCN" SourceColumnNullMapping="false" SourceVersion="Current" />
492 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PermanentAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PermanentAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
493 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TemporaryAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TemporaryAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
494 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
495 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
496 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
497 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
498 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AdmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AdmissionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
499 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Current" />
500 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Caste" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Caste" SourceColumnNullMapping="false" SourceVersion="Current" />
501 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Religion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Religion" SourceColumnNullMapping="false" SourceVersion="Current" />
502 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
503 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
504 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nationality" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
505 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Current" />
506 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastSchoolAttended" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastSchoolAttended" SourceColumnNullMapping="false" SourceVersion="Current" />
507 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Result" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Current" />
508 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PassPercentage" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PassPercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
509 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
510 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_AdmissionNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="AdmissionNo" SourceColumnNullMapping="false" SourceVersion="Original" />
511 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnrollmentNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentNo" SourceColumnNullMapping="true" SourceVersion="Original" />
512 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EnrollmentNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EnrollmentNo" SourceColumnNullMapping="false" SourceVersion="Original" />
513 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GRNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GRNo" SourceColumnNullMapping="true" SourceVersion="Original" />
514 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GRNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GRNo" SourceColumnNullMapping="false" SourceVersion="Original" />
515 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="true" SourceVersion="Original" />
516 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Original" />
517 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Original" />
518 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FatherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherName" SourceColumnNullMapping="false" SourceVersion="Original" />
519 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MotherName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MotherName" SourceColumnNullMapping="false" SourceVersion="Original" />
520 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FatherCN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FatherCN" SourceColumnNullMapping="true" SourceVersion="Original" />
521 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FatherCN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FatherCN" SourceColumnNullMapping="false" SourceVersion="Original" />
522 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PermanentAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PermanentAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
523 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TemporaryAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TemporaryAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
524 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
525 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
526 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
527 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DOB" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Original" />
528 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" />
529 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_AdmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AdmissionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
530 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Session" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Session" SourceColumnNullMapping="false" SourceVersion="Original" />
531 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Caste" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Caste" SourceColumnNullMapping="false" SourceVersion="Original" />
532 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Religion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Religion" SourceColumnNullMapping="false" SourceVersion="Original" />
533 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SectionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionID" SourceColumnNullMapping="false" SourceVersion="Original" />
534 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="true" SourceVersion="Original" />
535 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nationality" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="false" SourceVersion="Original" />
536 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SchoolID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SchoolID" SourceColumnNullMapping="false" SourceVersion="Original" />
537 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastSchoolAttended" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastSchoolAttended" SourceColumnNullMapping="true" SourceVersion="Original" />
538 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastSchoolAttended" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastSchoolAttended" SourceColumnNullMapping="false" SourceVersion="Original" />
539 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Result" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="true" SourceVersion="Original" />
540 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Result" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Original" />
541 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PassPercentage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PassPercentage" SourceColumnNullMapping="true" SourceVersion="Original" />
542 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PassPercentage" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PassPercentage" SourceColumnNullMapping="false" SourceVersion="Original" />
543 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
544 </Parameters>
545 </DbCommand>
546 </UpdateCommand>
547 </DbSource>
548 </MainSource>
549 <Mappings>
550 <Mapping SourceColumn="AdmissionNo" DataSetColumn="AdmissionNo" />
551 <Mapping SourceColumn="EnrollmentNo" DataSetColumn="EnrollmentNo" />
552 <Mapping SourceColumn="GRNo" DataSetColumn="GRNo" />
553 <Mapping SourceColumn="UID" DataSetColumn="UID" />
554 <Mapping SourceColumn="StudentName" DataSetColumn="StudentName" />
555 <Mapping SourceColumn="FatherName" DataSetColumn="FatherName" />
556 <Mapping SourceColumn="MotherName" DataSetColumn="MotherName" />
557 <Mapping SourceColumn="FatherCN" DataSetColumn="FatherCN" />
558 <Mapping SourceColumn="PermanentAddress" DataSetColumn="PermanentAddress" />
559 <Mapping SourceColumn="TemporaryAddress" DataSetColumn="TemporaryAddress" />
560 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
561 <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
562 <Mapping SourceColumn="DOB" DataSetColumn="DOB" />
563 <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
564 <Mapping SourceColumn="AdmissionDate" DataSetColumn="AdmissionDate" />
565 <Mapping SourceColumn="Session" DataSetColumn="Session" />
566 <Mapping SourceColumn="Caste" DataSetColumn="Caste" />
567 <Mapping SourceColumn="Religion" DataSetColumn="Religion" />
568 <Mapping SourceColumn="SectionID" DataSetColumn="SectionID" />
569 <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
570 <Mapping SourceColumn="Nationality" DataSetColumn="Nationality" />
571 <Mapping SourceColumn="SchoolID" DataSetColumn="SchoolID" />
572 <Mapping SourceColumn="LastSchoolAttended" DataSetColumn="LastSchoolAttended" />
573 <Mapping SourceColumn="Result" DataSetColumn="Result" />
574 <Mapping SourceColumn="PassPercentage" DataSetColumn="PassPercentage" />
575 <Mapping SourceColumn="Status" DataSetColumn="Status" />
576 </Mappings>
577 <Sources />
578 </TableAdapter>
579 </Tables>
580 <Sources />
581 </DataSource>
582 </xs:appinfo>
583 </xs:annotation>
584 <xs:element name="Class_DBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Class_DBDataSet" msprop:Generator_UserDSName="Class_DBDataSet">
585 <xs:complexType>
586 <xs:choice minOccurs="0" maxOccurs="unbounded">
587 <xs:element name="Class" msprop:Generator_TableClassName="ClassDataTable" msprop:Generator_TableVarName="tableClass" msprop:Generator_RowChangedName="ClassRowChanged" msprop:Generator_TablePropName="_Class" msprop:Generator_RowDeletingName="ClassRowDeleting" msprop:Generator_RowChangingName="ClassRowChanging" msprop:Generator_RowEvHandlerName="ClassRowChangeEventHandler" msprop:Generator_RowDeletedName="ClassRowDeleted" msprop:Generator_RowClassName="ClassRow" msprop:Generator_UserTableName="Class" msprop:Generator_RowEvArgName="ClassRowChangeEvent">
588 <xs:complexType>
589 <xs:sequence>
590 <xs:element name="ClassName" msprop:Generator_ColumnVarNameInTable="columnClassName" msprop:Generator_ColumnPropNameInRow="ClassName" msprop:Generator_ColumnPropNameInTable="ClassNameColumn" msprop:Generator_UserColumnName="ClassName">
591 <xs:simpleType>
592 <xs:restriction base="xs:string">
593 <xs:maxLength value="100" />
594 </xs:restriction>
595 </xs:simpleType>
596 </xs:element>
597 <xs:element name="ClassType" msprop:Generator_ColumnVarNameInTable="columnClassType" msprop:Generator_ColumnPropNameInRow="ClassType" msprop:Generator_ColumnPropNameInTable="ClassTypeColumn" msprop:Generator_UserColumnName="ClassType">
598 <xs:simpleType>
599 <xs:restriction base="xs:string">
600 <xs:maxLength value="150" />
601 </xs:restriction>
602 </xs:simpleType>
603 </xs:element>
604 </xs:sequence>
605 </xs:complexType>
606 </xs:element>
607 <xs:element name="CourseFee" msprop:Generator_TableClassName="CourseFeeDataTable" msprop:Generator_TableVarName="tableCourseFee" msprop:Generator_RowChangedName="CourseFeeRowChanged" msprop:Generator_TablePropName="CourseFee" msprop:Generator_RowDeletingName="CourseFeeRowDeleting" msprop:Generator_RowChangingName="CourseFeeRowChanging" msprop:Generator_RowEvHandlerName="CourseFeeRowChangeEventHandler" msprop:Generator_RowDeletedName="CourseFeeRowDeleted" msprop:Generator_RowClassName="CourseFeeRow" msprop:Generator_UserTableName="CourseFee" msprop:Generator_RowEvArgName="CourseFeeRowChangeEvent">
608 <xs:complexType>
609 <xs:sequence>
610 <xs:element name="C_ID" msprop:Generator_ColumnVarNameInTable="columnC_ID" msprop:Generator_ColumnPropNameInRow="C_ID" msprop:Generator_ColumnPropNameInTable="C_IDColumn" msprop:Generator_UserColumnName="C_ID" type="xs:int" />
611 <xs:element name="SchoolID" msprop:Generator_ColumnVarNameInTable="columnSchoolID" msprop:Generator_ColumnPropNameInRow="SchoolID" msprop:Generator_ColumnPropNameInTable="SchoolIDColumn" msprop:Generator_UserColumnName="SchoolID" type="xs:int" />
612 <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="_Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class">
613 <xs:simpleType>
614 <xs:restriction base="xs:string">
615 <xs:maxLength value="100" />
616 </xs:restriction>
617 </xs:simpleType>
618 </xs:element>
619 <xs:element name="FeeName" msprop:Generator_ColumnVarNameInTable="columnFeeName" msprop:Generator_ColumnPropNameInRow="FeeName" msprop:Generator_ColumnPropNameInTable="FeeNameColumn" msprop:Generator_UserColumnName="FeeName">
620 <xs:simpleType>
621 <xs:restriction base="xs:string">
622 <xs:maxLength value="250" />
623 </xs:restriction>
624 </xs:simpleType>
625 </xs:element>
626 <xs:element name="Semester" msprop:Generator_ColumnVarNameInTable="columnSemester" msprop:Generator_ColumnPropNameInRow="Semester" msprop:Generator_ColumnPropNameInTable="SemesterColumn" msprop:Generator_UserColumnName="Semester">
627 <xs:simpleType>
628 <xs:restriction base="xs:string">
629 <xs:maxLength value="30" />
630 </xs:restriction>
631 </xs:simpleType>
632 </xs:element>
633 <xs:element name="Fee" msprop:Generator_ColumnVarNameInTable="columnFee" msprop:Generator_ColumnPropNameInRow="Fee" msprop:Generator_ColumnPropNameInTable="FeeColumn" msprop:Generator_UserColumnName="Fee" type="xs:decimal" />
634 </xs:sequence>
635 </xs:complexType>
636 </xs:element>
637 <xs:element name="CourseFeePayment" msprop:Generator_TableClassName="CourseFeePaymentDataTable" msprop:Generator_TableVarName="tableCourseFeePayment" msprop:Generator_RowChangedName="CourseFeePaymentRowChanged" msprop:Generator_TablePropName="CourseFeePayment" msprop:Generator_RowDeletingName="CourseFeePaymentRowDeleting" msprop:Generator_RowChangingName="CourseFeePaymentRowChanging" msprop:Generator_RowEvHandlerName="CourseFeePaymentRowChangeEventHandler" msprop:Generator_RowDeletedName="CourseFeePaymentRowDeleted" msprop:Generator_RowClassName="CourseFeePaymentRow" msprop:Generator_UserTableName="CourseFeePayment" msprop:Generator_RowEvArgName="CourseFeePaymentRowChangeEvent">
638 <xs:complexType>
639 <xs:sequence>
640 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
641 <xs:element name="CFP_ID" msprop:Generator_ColumnVarNameInTable="columnCFP_ID" msprop:Generator_ColumnPropNameInRow="CFP_ID" msprop:Generator_ColumnPropNameInTable="CFP_IDColumn" msprop:Generator_UserColumnName="CFP_ID" type="xs:int" />
642 <xs:element name="PaymentID" msprop:Generator_ColumnVarNameInTable="columnPaymentID" msprop:Generator_ColumnPropNameInRow="PaymentID" msprop:Generator_ColumnPropNameInTable="PaymentIDColumn" msprop:Generator_UserColumnName="PaymentID">
643 <xs:simpleType>
644 <xs:restriction base="xs:string">
645 <xs:maxLength value="30" />
646 </xs:restriction>
647 </xs:simpleType>
648 </xs:element>
649 <xs:element name="AdmissionNo" msprop:Generator_ColumnVarNameInTable="columnAdmissionNo" msprop:Generator_ColumnPropNameInRow="AdmissionNo" msprop:Generator_ColumnPropNameInTable="AdmissionNoColumn" msprop:Generator_UserColumnName="AdmissionNo">
650 <xs:simpleType>
651 <xs:restriction base="xs:string">
652 <xs:maxLength value="15" />
653 </xs:restriction>
654 </xs:simpleType>
655 </xs:element>
656 <xs:element name="Session" msprop:Generator_ColumnVarNameInTable="columnSession" msprop:Generator_ColumnPropNameInRow="Session" msprop:Generator_ColumnPropNameInTable="SessionColumn" msprop:Generator_UserColumnName="Session">
657 <xs:simpleType>
658 <xs:restriction base="xs:string">
659 <xs:maxLength value="15" />
660 </xs:restriction>
661 </xs:simpleType>
662 </xs:element>
663 <xs:element name="Semester" msprop:Generator_ColumnVarNameInTable="columnSemester" msprop:Generator_ColumnPropNameInRow="Semester" msprop:Generator_ColumnPropNameInTable="SemesterColumn" msprop:Generator_UserColumnName="Semester">
664 <xs:simpleType>
665 <xs:restriction base="xs:string">
666 <xs:maxLength value="10" />
667 </xs:restriction>
668 </xs:simpleType>
669 </xs:element>
670 <xs:element name="TotalFee" msprop:Generator_ColumnVarNameInTable="columnTotalFee" msprop:Generator_ColumnPropNameInRow="TotalFee" msprop:Generator_ColumnPropNameInTable="TotalFeeColumn" msprop:Generator_UserColumnName="TotalFee" type="xs:decimal" />
671 <xs:element name="DiscountPer" msprop:Generator_ColumnVarNameInTable="columnDiscountPer" msprop:Generator_ColumnPropNameInRow="DiscountPer" msprop:Generator_ColumnPropNameInTable="DiscountPerColumn" msprop:Generator_UserColumnName="DiscountPer" type="xs:decimal" />
672 <xs:element name="DiscountAmt" msprop:Generator_ColumnVarNameInTable="columnDiscountAmt" msprop:Generator_ColumnPropNameInRow="DiscountAmt" msprop:Generator_ColumnPropNameInTable="DiscountAmtColumn" msprop:Generator_UserColumnName="DiscountAmt" type="xs:decimal" />
673 <xs:element name="PreviousDue" msprop:Generator_ColumnVarNameInTable="columnPreviousDue" msprop:Generator_ColumnPropNameInRow="PreviousDue" msprop:Generator_ColumnPropNameInTable="PreviousDueColumn" msprop:Generator_UserColumnName="PreviousDue" type="xs:decimal" />
674 <xs:element name="Fine" msprop:Generator_ColumnVarNameInTable="columnFine" msprop:Generator_ColumnPropNameInRow="Fine" msprop:Generator_ColumnPropNameInTable="FineColumn" msprop:Generator_UserColumnName="Fine" type="xs:decimal" />
675 <xs:element name="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" msprop:Generator_UserColumnName="GrandTotal" type="xs:decimal" />
676 <xs:element name="TotalPaid" msprop:Generator_ColumnVarNameInTable="columnTotalPaid" msprop:Generator_ColumnPropNameInRow="TotalPaid" msprop:Generator_ColumnPropNameInTable="TotalPaidColumn" msprop:Generator_UserColumnName="TotalPaid" type="xs:decimal" />
677 <xs:element name="ModeOfPayment" msprop:Generator_ColumnVarNameInTable="columnModeOfPayment" msprop:Generator_ColumnPropNameInRow="ModeOfPayment" msprop:Generator_ColumnPropNameInTable="ModeOfPaymentColumn" msprop:Generator_UserColumnName="ModeOfPayment">
678 <xs:simpleType>
679 <xs:restriction base="xs:string">
680 <xs:maxLength value="100" />
681 </xs:restriction>
682 </xs:simpleType>
683 </xs:element>
684 <xs:element name="PaymentModeDetails" msprop:Generator_ColumnVarNameInTable="columnPaymentModeDetails" msprop:Generator_ColumnPropNameInRow="PaymentModeDetails" msprop:Generator_ColumnPropNameInTable="PaymentModeDetailsColumn" msprop:Generator_UserColumnName="PaymentModeDetails" minOccurs="0">
685 <xs:simpleType>
686 <xs:restriction base="xs:string">
687 <xs:maxLength value="250" />
688 </xs:restriction>
689 </xs:simpleType>
690 </xs:element>
691 <xs:element name="PaymentDate" msprop:Generator_ColumnVarNameInTable="columnPaymentDate" msprop:Generator_ColumnPropNameInRow="PaymentDate" msprop:Generator_ColumnPropNameInTable="PaymentDateColumn" msprop:Generator_UserColumnName="PaymentDate" type="xs:dateTime" />
692 <xs:element name="PaymentDue" msprop:Generator_ColumnVarNameInTable="columnPaymentDue" msprop:Generator_ColumnPropNameInRow="PaymentDue" msprop:Generator_ColumnPropNameInTable="PaymentDueColumn" msprop:Generator_UserColumnName="PaymentDue" type="xs:decimal" />
693 <xs:element name="ClassType" msprop:Generator_ColumnVarNameInTable="columnClassType" msprop:Generator_ColumnPropNameInRow="ClassType" msprop:Generator_ColumnPropNameInTable="ClassTypeColumn" msprop:Generator_UserColumnName="ClassType">
694 <xs:simpleType>
695 <xs:restriction base="xs:string">
696 <xs:maxLength value="150" />
697 </xs:restriction>
698 </xs:simpleType>
699 </xs:element>
700 <xs:element name="SchoolType" msprop:Generator_ColumnVarNameInTable="columnSchoolType" msprop:Generator_ColumnPropNameInRow="SchoolType" msprop:Generator_ColumnPropNameInTable="SchoolTypeColumn" msprop:Generator_UserColumnName="SchoolType">
701 <xs:simpleType>
702 <xs:restriction base="xs:string">
703 <xs:maxLength value="150" />
704 </xs:restriction>
705 </xs:simpleType>
706 </xs:element>
707 <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="_Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class">
708 <xs:simpleType>
709 <xs:restriction base="xs:string">
710 <xs:maxLength value="100" />
711 </xs:restriction>
712 </xs:simpleType>
713 </xs:element>
714 <xs:element name="Section" msprop:Generator_ColumnVarNameInTable="columnSection" msprop:Generator_ColumnPropNameInRow="Section" msprop:Generator_ColumnPropNameInTable="SectionColumn" msprop:Generator_UserColumnName="Section">
715 <xs:simpleType>
716 <xs:restriction base="xs:string">
717 <xs:maxLength value="15" />
718 </xs:restriction>
719 </xs:simpleType>
720 </xs:element>
721 </xs:sequence>
722 </xs:complexType>
723 </xs:element>
724 <xs:element name="SchoolInfo" msprop:Generator_TableClassName="SchoolInfoDataTable" msprop:Generator_TableVarName="tableSchoolInfo" msprop:Generator_RowChangedName="SchoolInfoRowChanged" msprop:Generator_TablePropName="SchoolInfo" msprop:Generator_RowDeletingName="SchoolInfoRowDeleting" msprop:Generator_RowChangingName="SchoolInfoRowChanging" msprop:Generator_RowEvHandlerName="SchoolInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="SchoolInfoRowDeleted" msprop:Generator_RowClassName="SchoolInfoRow" msprop:Generator_UserTableName="SchoolInfo" msprop:Generator_RowEvArgName="SchoolInfoRowChangeEvent">
725 <xs:complexType>
726 <xs:sequence>
727 <xs:element name="S_Id" msprop:Generator_ColumnVarNameInTable="columnS_Id" msprop:Generator_ColumnPropNameInRow="S_Id" msprop:Generator_ColumnPropNameInTable="S_IdColumn" msprop:Generator_UserColumnName="S_Id" type="xs:int" />
728 <xs:element name="SchoolName" msprop:Generator_ColumnVarNameInTable="columnSchoolName" msprop:Generator_ColumnPropNameInRow="SchoolName" msprop:Generator_ColumnPropNameInTable="SchoolNameColumn" msprop:Generator_UserColumnName="SchoolName">
729 <xs:simpleType>
730 <xs:restriction base="xs:string">
731 <xs:maxLength value="250" />
732 </xs:restriction>
733 </xs:simpleType>
734 </xs:element>
735 <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
736 <xs:simpleType>
737 <xs:restriction base="xs:string">
738 <xs:maxLength value="250" />
739 </xs:restriction>
740 </xs:simpleType>
741 </xs:element>
742 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
743 <xs:simpleType>
744 <xs:restriction base="xs:string">
745 <xs:maxLength value="50" />
746 </xs:restriction>
747 </xs:simpleType>
748 </xs:element>
749 <xs:element name="AltContactNo" msprop:Generator_ColumnVarNameInTable="columnAltContactNo" msprop:Generator_ColumnPropNameInRow="AltContactNo" msprop:Generator_ColumnPropNameInTable="AltContactNoColumn" msprop:Generator_UserColumnName="AltContactNo" minOccurs="0">
750 <xs:simpleType>
751 <xs:restriction base="xs:string">
752 <xs:maxLength value="50" />
753 </xs:restriction>
754 </xs:simpleType>
755 </xs:element>
756 <xs:element name="FaxNo" msprop:Generator_ColumnVarNameInTable="columnFaxNo" msprop:Generator_ColumnPropNameInRow="FaxNo" msprop:Generator_ColumnPropNameInTable="FaxNoColumn" msprop:Generator_UserColumnName="FaxNo" minOccurs="0">
757 <xs:simpleType>
758 <xs:restriction base="xs:string">
759 <xs:maxLength value="50" />
760 </xs:restriction>
761 </xs:simpleType>
762 </xs:element>
763 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email">
764 <xs:simpleType>
765 <xs:restriction base="xs:string">
766 <xs:maxLength value="250" />
767 </xs:restriction>
768 </xs:simpleType>
769 </xs:element>
770 <xs:element name="Website" msprop:Generator_ColumnVarNameInTable="columnWebsite" msprop:Generator_ColumnPropNameInRow="Website" msprop:Generator_ColumnPropNameInTable="WebsiteColumn" msprop:Generator_UserColumnName="Website" minOccurs="0">
771 <xs:simpleType>
772 <xs:restriction base="xs:string">
773 <xs:maxLength value="250" />
774 </xs:restriction>
775 </xs:simpleType>
776 </xs:element>
777 <xs:element name="Logo" msprop:Generator_ColumnVarNameInTable="columnLogo" msprop:Generator_ColumnPropNameInRow="Logo" msprop:Generator_ColumnPropNameInTable="LogoColumn" msprop:Generator_UserColumnName="Logo" type="xs:base64Binary" />
778 <xs:element name="RegistrationNo" msprop:Generator_ColumnVarNameInTable="columnRegistrationNo" msprop:Generator_ColumnPropNameInRow="RegistrationNo" msprop:Generator_ColumnPropNameInTable="RegistrationNoColumn" msprop:Generator_UserColumnName="RegistrationNo" minOccurs="0">
779 <xs:simpleType>
780 <xs:restriction base="xs:string">
781 <xs:maxLength value="150" />
782 </xs:restriction>
783 </xs:simpleType>
784 </xs:element>
785 <xs:element name="DiseNo" msprop:Generator_ColumnVarNameInTable="columnDiseNo" msprop:Generator_ColumnPropNameInRow="DiseNo" msprop:Generator_ColumnPropNameInTable="DiseNoColumn" msprop:Generator_UserColumnName="DiseNo" minOccurs="0">
786 <xs:simpleType>
787 <xs:restriction base="xs:string">
788 <xs:maxLength value="150" />
789 </xs:restriction>
790 </xs:simpleType>
791 </xs:element>
792 <xs:element name="IndexNo" msprop:Generator_ColumnVarNameInTable="columnIndexNo" msprop:Generator_ColumnPropNameInRow="IndexNo" msprop:Generator_ColumnPropNameInTable="IndexNoColumn" msprop:Generator_UserColumnName="IndexNo" minOccurs="0">
793 <xs:simpleType>
794 <xs:restriction base="xs:string">
795 <xs:maxLength value="10" />
796 </xs:restriction>
797 </xs:simpleType>
798 </xs:element>
799 <xs:element name="EstablishedYear" msprop:Generator_ColumnVarNameInTable="columnEstablishedYear" msprop:Generator_ColumnPropNameInRow="EstablishedYear" msprop:Generator_ColumnPropNameInTable="EstablishedYearColumn" msprop:Generator_UserColumnName="EstablishedYear" type="xs:int" />
800 <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="_Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class" minOccurs="0">
801 <xs:simpleType>
802 <xs:restriction base="xs:string">
803 <xs:maxLength value="50" />
804 </xs:restriction>
805 </xs:simpleType>
806 </xs:element>
807 <xs:element name="SchoolType" msprop:Generator_ColumnVarNameInTable="columnSchoolType" msprop:Generator_ColumnPropNameInRow="SchoolType" msprop:Generator_ColumnPropNameInTable="SchoolTypeColumn" msprop:Generator_UserColumnName="SchoolType">
808 <xs:simpleType>
809 <xs:restriction base="xs:string">
810 <xs:maxLength value="150" />
811 </xs:restriction>
812 </xs:simpleType>
813 </xs:element>
814 </xs:sequence>
815 </xs:complexType>
816 </xs:element>
817 <xs:element name="Student" msprop:Generator_TableClassName="StudentDataTable" msprop:Generator_TableVarName="tableStudent" msprop:Generator_RowChangedName="StudentRowChanged" msprop:Generator_TablePropName="Student" msprop:Generator_RowDeletingName="StudentRowDeleting" msprop:Generator_RowChangingName="StudentRowChanging" msprop:Generator_RowEvHandlerName="StudentRowChangeEventHandler" msprop:Generator_RowDeletedName="StudentRowDeleted" msprop:Generator_RowClassName="StudentRow" msprop:Generator_UserTableName="Student" msprop:Generator_RowEvArgName="StudentRowChangeEvent">
818 <xs:complexType>
819 <xs:sequence>
820 <xs:element name="AdmissionNo" msprop:Generator_ColumnVarNameInTable="columnAdmissionNo" msprop:Generator_ColumnPropNameInRow="AdmissionNo" msprop:Generator_ColumnPropNameInTable="AdmissionNoColumn" msprop:Generator_UserColumnName="AdmissionNo">
821 <xs:simpleType>
822 <xs:restriction base="xs:string">
823 <xs:maxLength value="15" />
824 </xs:restriction>
825 </xs:simpleType>
826 </xs:element>
827 <xs:element name="EnrollmentNo" msprop:Generator_ColumnVarNameInTable="columnEnrollmentNo" msprop:Generator_ColumnPropNameInRow="EnrollmentNo" msprop:Generator_ColumnPropNameInTable="EnrollmentNoColumn" msprop:Generator_UserColumnName="EnrollmentNo" minOccurs="0">
828 <xs:simpleType>
829 <xs:restriction base="xs:string">
830 <xs:maxLength value="15" />
831 </xs:restriction>
832 </xs:simpleType>
833 </xs:element>
834 <xs:element name="GRNo" msprop:Generator_ColumnVarNameInTable="columnGRNo" msprop:Generator_ColumnPropNameInRow="GRNo" msprop:Generator_ColumnPropNameInTable="GRNoColumn" msprop:Generator_UserColumnName="GRNo" minOccurs="0">
835 <xs:simpleType>
836 <xs:restriction base="xs:string">
837 <xs:maxLength value="50" />
838 </xs:restriction>
839 </xs:simpleType>
840 </xs:element>
841 <xs:element name="UID" msprop:Generator_ColumnVarNameInTable="columnUID" msprop:Generator_ColumnPropNameInRow="UID" msprop:Generator_ColumnPropNameInTable="UIDColumn" msprop:Generator_UserColumnName="UID" minOccurs="0">
842 <xs:simpleType>
843 <xs:restriction base="xs:string">
844 <xs:maxLength value="50" />
845 </xs:restriction>
846 </xs:simpleType>
847 </xs:element>
848 <xs:element name="StudentName" msprop:Generator_ColumnVarNameInTable="columnStudentName" msprop:Generator_ColumnPropNameInRow="StudentName" msprop:Generator_ColumnPropNameInTable="StudentNameColumn" msprop:Generator_UserColumnName="StudentName">
849 <xs:simpleType>
850 <xs:restriction base="xs:string">
851 <xs:maxLength value="100" />
852 </xs:restriction>
853 </xs:simpleType>
854 </xs:element>
855 <xs:element name="FatherName" msprop:Generator_ColumnVarNameInTable="columnFatherName" msprop:Generator_ColumnPropNameInRow="FatherName" msprop:Generator_ColumnPropNameInTable="FatherNameColumn" msprop:Generator_UserColumnName="FatherName">
856 <xs:simpleType>
857 <xs:restriction base="xs:string">
858 <xs:maxLength value="100" />
859 </xs:restriction>
860 </xs:simpleType>
861 </xs:element>
862 <xs:element name="MotherName" msprop:Generator_ColumnVarNameInTable="columnMotherName" msprop:Generator_ColumnPropNameInRow="MotherName" msprop:Generator_ColumnPropNameInTable="MotherNameColumn" msprop:Generator_UserColumnName="MotherName">
863 <xs:simpleType>
864 <xs:restriction base="xs:string">
865 <xs:maxLength value="100" />
866 </xs:restriction>
867 </xs:simpleType>
868 </xs:element>
869 <xs:element name="FatherCN" msprop:Generator_ColumnVarNameInTable="columnFatherCN" msprop:Generator_ColumnPropNameInRow="FatherCN" msprop:Generator_ColumnPropNameInTable="FatherCNColumn" msprop:Generator_UserColumnName="FatherCN" minOccurs="0">
870 <xs:simpleType>
871 <xs:restriction base="xs:string">
872 <xs:maxLength value="15" />
873 </xs:restriction>
874 </xs:simpleType>
875 </xs:element>
876 <xs:element name="PermanentAddress" msprop:Generator_ColumnVarNameInTable="columnPermanentAddress" msprop:Generator_ColumnPropNameInRow="PermanentAddress" msprop:Generator_ColumnPropNameInTable="PermanentAddressColumn" msprop:Generator_UserColumnName="PermanentAddress">
877 <xs:simpleType>
878 <xs:restriction base="xs:string">
879 <xs:maxLength value="250" />
880 </xs:restriction>
881 </xs:simpleType>
882 </xs:element>
883 <xs:element name="TemporaryAddress" msprop:Generator_ColumnVarNameInTable="columnTemporaryAddress" msprop:Generator_ColumnPropNameInRow="TemporaryAddress" msprop:Generator_ColumnPropNameInTable="TemporaryAddressColumn" msprop:Generator_UserColumnName="TemporaryAddress">
884 <xs:simpleType>
885 <xs:restriction base="xs:string">
886 <xs:maxLength value="250" />
887 </xs:restriction>
888 </xs:simpleType>
889 </xs:element>
890 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
891 <xs:simpleType>
892 <xs:restriction base="xs:string">
893 <xs:maxLength value="15" />
894 </xs:restriction>
895 </xs:simpleType>
896 </xs:element>
897 <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID" minOccurs="0">
898 <xs:simpleType>
899 <xs:restriction base="xs:string">
900 <xs:maxLength value="250" />
901 </xs:restriction>
902 </xs:simpleType>
903 </xs:element>
904 <xs:element name="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" msprop:Generator_UserColumnName="DOB" type="xs:dateTime" />
905 <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender">
906 <xs:simpleType>
907 <xs:restriction base="xs:string">
908 <xs:maxLength value="10" />
909 </xs:restriction>
910 </xs:simpleType>
911 </xs:element>
912 <xs:element name="AdmissionDate" msprop:Generator_ColumnVarNameInTable="columnAdmissionDate" msprop:Generator_ColumnPropNameInRow="AdmissionDate" msprop:Generator_ColumnPropNameInTable="AdmissionDateColumn" msprop:Generator_UserColumnName="AdmissionDate" type="xs:dateTime" />
913 <xs:element name="Session" msprop:Generator_ColumnVarNameInTable="columnSession" msprop:Generator_ColumnPropNameInRow="Session" msprop:Generator_ColumnPropNameInTable="SessionColumn" msprop:Generator_UserColumnName="Session">
914 <xs:simpleType>
915 <xs:restriction base="xs:string">
916 <xs:maxLength value="15" />
917 </xs:restriction>
918 </xs:simpleType>
919 </xs:element>
920 <xs:element name="Caste" msprop:Generator_ColumnVarNameInTable="columnCaste" msprop:Generator_ColumnPropNameInRow="Caste" msprop:Generator_ColumnPropNameInTable="CasteColumn" msprop:Generator_UserColumnName="Caste">
921 <xs:simpleType>
922 <xs:restriction base="xs:string">
923 <xs:maxLength value="15" />
924 </xs:restriction>
925 </xs:simpleType>
926 </xs:element>
927 <xs:element name="Religion" msprop:Generator_ColumnVarNameInTable="columnReligion" msprop:Generator_ColumnPropNameInRow="Religion" msprop:Generator_ColumnPropNameInTable="ReligionColumn" msprop:Generator_UserColumnName="Religion">
928 <xs:simpleType>
929 <xs:restriction base="xs:string">
930 <xs:maxLength value="15" />
931 </xs:restriction>
932 </xs:simpleType>
933 </xs:element>
934 <xs:element name="SectionID" msprop:Generator_ColumnVarNameInTable="columnSectionID" msprop:Generator_ColumnPropNameInRow="SectionID" msprop:Generator_ColumnPropNameInTable="SectionIDColumn" msprop:Generator_UserColumnName="SectionID" type="xs:int" />
935 <xs:element name="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" />
936 <xs:element name="Nationality" msprop:Generator_ColumnVarNameInTable="columnNationality" msprop:Generator_ColumnPropNameInRow="Nationality" msprop:Generator_ColumnPropNameInTable="NationalityColumn" msprop:Generator_UserColumnName="Nationality" minOccurs="0">
937 <xs:simpleType>
938 <xs:restriction base="xs:string">
939 <xs:maxLength value="100" />
940 </xs:restriction>
941 </xs:simpleType>
942 </xs:element>
943 <xs:element name="SchoolID" msprop:Generator_ColumnVarNameInTable="columnSchoolID" msprop:Generator_ColumnPropNameInRow="SchoolID" msprop:Generator_ColumnPropNameInTable="SchoolIDColumn" msprop:Generator_UserColumnName="SchoolID" type="xs:int" />
944 <xs:element name="LastSchoolAttended" msprop:Generator_ColumnVarNameInTable="columnLastSchoolAttended" msprop:Generator_ColumnPropNameInRow="LastSchoolAttended" msprop:Generator_ColumnPropNameInTable="LastSchoolAttendedColumn" msprop:Generator_UserColumnName="LastSchoolAttended" minOccurs="0">
945 <xs:simpleType>
946 <xs:restriction base="xs:string">
947 <xs:maxLength value="250" />
948 </xs:restriction>
949 </xs:simpleType>
950 </xs:element>
951 <xs:element name="Result" msprop:Generator_ColumnVarNameInTable="columnResult" msprop:Generator_ColumnPropNameInRow="Result" msprop:Generator_ColumnPropNameInTable="ResultColumn" msprop:Generator_UserColumnName="Result" minOccurs="0">
952 <xs:simpleType>
953 <xs:restriction base="xs:string">
954 <xs:maxLength value="20" />
955 </xs:restriction>
956 </xs:simpleType>
957 </xs:element>
958 <xs:element name="PassPercentage" msprop:Generator_ColumnVarNameInTable="columnPassPercentage" msprop:Generator_ColumnPropNameInRow="PassPercentage" msprop:Generator_ColumnPropNameInTable="PassPercentageColumn" msprop:Generator_UserColumnName="PassPercentage" minOccurs="0">
959 <xs:simpleType>
960 <xs:restriction base="xs:string">
961 <xs:maxLength value="10" />
962 </xs:restriction>
963 </xs:simpleType>
964 </xs:element>
965 <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status">
966 <xs:simpleType>
967 <xs:restriction base="xs:string">
968 <xs:maxLength value="15" />
969 </xs:restriction>
970 </xs:simpleType>
971 </xs:element>
972 </xs:sequence>
973 </xs:complexType>
974 </xs:element>
975 </xs:choice>
976 </xs:complexType>
977 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
978 <xs:selector xpath=".//mstns:Class" />
979 <xs:field xpath="mstns:ClassName" />
980 </xs:unique>
981 <xs:unique name="CourseFee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
982 <xs:selector xpath=".//mstns:CourseFee" />
983 <xs:field xpath="mstns:C_ID" />
984 </xs:unique>
985 <xs:unique name="Constraint2">
986 <xs:selector xpath=".//mstns:CourseFee" />
987 <xs:field xpath="mstns:Semester" />
988 </xs:unique>
989 <xs:unique name="CourseFeePayment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
990 <xs:selector xpath=".//mstns:CourseFeePayment" />
991 <xs:field xpath="mstns:Id" />
992 </xs:unique>
993 <xs:unique name="SchoolInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
994 <xs:selector xpath=".//mstns:SchoolInfo" />
995 <xs:field xpath="mstns:S_Id" />
996 </xs:unique>
997 <xs:unique name="Student_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
998 <xs:selector xpath=".//mstns:Student" />
999 <xs:field xpath="mstns:AdmissionNo" />
1000 </xs:unique>
1001 <xs:keyref name="FK_CourseFee_CourseFeePayment" refer="Constraint2" msprop:rel_Generator_UserChildTable="CourseFeePayment" msprop:rel_Generator_ChildPropName="GetCourseFeePaymentRows" msprop:rel_Generator_UserRelationName="FK_CourseFee_CourseFeePayment" msprop:rel_Generator_ParentPropName="CourseFeeRow" msprop:rel_Generator_RelationVarName="relationFK_CourseFee_CourseFeePayment" msprop:rel_Generator_UserParentTable="CourseFee" msdata:UpdateRule="None" msdata:DeleteRule="None">
1002 <xs:selector xpath=".//mstns:CourseFeePayment" />
1003 <xs:field xpath="mstns:Semester" />
1004 </xs:keyref>
1005 </xs:element>
1006 <xs:annotation>
1007 <xs:appinfo>
1008 <msdata:Relationship name="FK_CourseFee_CourseFee" msdata:parent="Class" msdata:child="CourseFee" msdata:parentkey="ClassName" msdata:childkey="Class" msprop:Generator_UserChildTable="CourseFee" msprop:Generator_ChildPropName="GetCourseFeeRows" msprop:Generator_UserRelationName="FK_CourseFee_CourseFee" msprop:Generator_RelationVarName="relationFK_CourseFee_CourseFee" msprop:Generator_UserParentTable="Class" msprop:Generator_ParentPropName="ClassRow" />
1009 <msdata:Relationship name="FK_CourseFee_SchoolInfo" msdata:parent="SchoolInfo" msdata:child="CourseFee" msdata:parentkey="S_Id" msdata:childkey="SchoolID" msprop:Generator_UserChildTable="CourseFee" msprop:Generator_ChildPropName="GetCourseFeeRows" msprop:Generator_UserRelationName="FK_CourseFee_SchoolInfo" msprop:Generator_ParentPropName="SchoolInfoRow" msprop:Generator_RelationVarName="relationFK_CourseFee_SchoolInfo" msprop:Generator_UserParentTable="SchoolInfo" />
1010 <msdata:Relationship name="FK_CourseFeePayment_Student" msdata:parent="Student" msdata:child="CourseFeePayment" msdata:parentkey="AdmissionNo" msdata:childkey="AdmissionNo" msprop:Generator_UserChildTable="CourseFeePayment" msprop:Generator_ChildPropName="GetCourseFeePaymentRows" msprop:Generator_UserRelationName="FK_CourseFeePayment_Student" msprop:Generator_ParentPropName="StudentRow" msprop:Generator_RelationVarName="relationFK_CourseFeePayment_Student" msprop:Generator_UserParentTable="Student" />
1011 <msdata:Relationship name="FK_Student_SchoolInfo" msdata:parent="SchoolInfo" msdata:child="Student" msdata:parentkey="S_Id" msdata:childkey="SchoolID" msprop:Generator_UserChildTable="Student" msprop:Generator_ChildPropName="GetStudentRows" msprop:Generator_UserRelationName="FK_Student_SchoolInfo" msprop:Generator_RelationVarName="relationFK_Student_SchoolInfo" msprop:Generator_UserParentTable="SchoolInfo" msprop:Generator_ParentPropName="SchoolInfoRow" />
1012 </xs:appinfo>
1013 </xs:annotation>
1014 </xs:schema>